package com.bf.electroplating.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bf.electroplating.pojo.entity.SewagePlantManualDetection;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 污水厂预排口手工检测数据表 Mapper 接口
 * </p>
 *
 * @author gzd
 * @since 2025-09-11
 */
public interface SewagePlantManualDetectionMapper extends BaseMapper<SewagePlantManualDetection> {

    @Select("select count(1) from (\n" +
            "select * from sewage_plant_manual_detection where input_by !='' group by PLANT_CODE ,detection_date)a")
    Integer getWastewaterTotalDetectionCount();
}
